FO_Tests

Basic test definitions.

This table requires a single record for each test code. Its purpose is to provide the basic definitions for each test.

 

Field Type Notes

Tests_ID

int

ID field, a counter. Unique

TestCode

varchar(50)

Enter a unique test code which corresponds to the LIS test code sent across the interfaces.

TestName

varchar(255)

Name for the test.

AltName

varchar(255)

A list of words used to search for this test.

Separate each word with a space.

The system typically does a "like" search so multiple values can be matched.

TestType

varchar(255)

Type of test.

Enter an allowed value.

Allowed values:

TEST = single test code

BAT = battery code

PKG = package code

Orderable

varchar(255)

Determines if the test is orderable.

Enter an allowed value.

Allowed values:

Y = orderable

N = not orderable

B = billable test

AnswerAtOrder

varchar(255)

Determines status of answeratorder.

Enter an allowed value.

Allowed values:

Y = yes

N = no

M = mandatory

Informational

LabDept

varchar(255)

Enter a valid lab department code.

PerformingLab

varchar(255)

Enter a valid performing lab code.

Informational

Test_Bat_in_Pkg

varchar(255)

Represents the tests and battery test codes within a package.

Critical field for package test overlap logic.

Multidimensional comma delimited value with leading and trailing commas.

Enter valid test codes separated by commas.

If the package contents are not orderable, consider making them orderable so overlapping logic will not fail.

IE: ,NA,K,CBC,

Components

varchar(800)

Represents the test codes within a battery.

Critical field for test overlap logic.

Multidimensional comma delimited value with leading and trailing commas.

Enter valid test codes separated by commas.

If the components are not orderable, consider making them orderable so overlapping logic will not fail.

IE: ,NA,K,CL,

ContainerCode

varchar(255)

Default container code for this test.

Enter a valid container code.

Used to combine or separate tests to a container ID or accession depending on rules.

Critical field for container processing.

If container rules will not be used it’s an informational component to assist with specimen collection.

ContainerType

varchar(255)

Name for the container code.

SpecimenCode

varchar(255)

Specimen code for this test.

Enter a valid specimen code as found in the FO_Types_Specimen table.

SpecimenType

varchar(255)

Represents the specimen code description.

Specimen code name for this test.

StorageCode

varchar(255)

Storage code.

Enter a valid storage code as found in the FO_Types_Container table.

StorageType

varchar(255)

Description for the storage code.

Volume

varchar(255)

Minimum volume required for this test collection in ML.

Instructions

varchar(4000)

Collection instructions for the person obtaining the specimen.

If the test includes a URL link beginning with HTTP as the last line, the system will enable a web link when the field on the order screen is selected, or clicked into.

Comments

varchar(255)

Default comments for this test.

DisplaySequence

varchar(255)

Future use

Send_to_LIS

int

Determines if the test should be transmitted on outbound interfaces.

Enter 0 or 1

0 = do not send test

1 = send test

Req_Dept

varchar(50)

Used to create separate requisitions for test groups when the REQ button on the order screen is clicked.

Enter a valid requisition department code to indicate that this test should be separated from other tests of different codes when printing a requisition.

Typically used to group pathology, micro and other specialty tests as separate requisitions.

SpeciesCode

varchar(50)

Default species code for which this test should be run.

Enter a valid species code.

TestInfo

text

Test related information which may be displayed when the Instruction button on the order screen test list is clicked.

ViewByLabOnly

varchar(255)

Determines if lab user can define a test.

[from KB -- check on 'define test']

Enter Y or N

Y = lab only

N or skip this entry = everyone

Used to separate some tests so they are only searchable by lab staff.

LabPopup

varchar(255)

Test specific message displayed by FAST when this test is ordered.

Enter a message for display.

This field is meant for lab use only.

ClientPopup

varchar(255)

Test specific message displayed by FAST when this test is ordered.

Enter a message for display.

This field is meant for client use only.

AutoOrder

varchar(255)

Defines the list of test codes that will automatically be ordered when this test code is ordered.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test codes separated by pipes.

AltTestCode

varchar(255)

Second test code for this test.

The system will check for both the test code and this code when it is entered on the order screen.

Active

varchar(255)

Determines if this test code is active and therefore searchable on the order screen.

Enter Y or N

Y or skip this entry = yes

N = not active

ResultUnits

varchar(4000)

Units for this test.

Informational

Sensitive

varchar(255)

Indicates if the test is sensitive.

Enter Y or N

N or skip this entry = no

Y = yes

AutoAnswerAtOrder

varchar(4000)

Informational

Used by Sunquest. Can be the coded result or free text result applied when test is ordered in Sunquest.

InterfaceCode

varchar(255)

Default interface code for this test.

Enter a valid interface code.

Skip this entry to use the system-level default.

Billable

varchar(255)

Determines if this test code is billable.

Enter Y or N

Y or skip this entry = yes

N = no

PercentDiscount

int

Defines the percent discount applied for this test when CASH is chosen as the Bill To on the order screen.

The rule, or calculation, is executed on the payment screen.

Enter an integer for the percent discount.

PerfLabAssignByINS

varchar(500)

Defines the list of insurance based performing lab rules.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid insurance based performing lab rules separated by pipes.

See performing lab module for more information.

OrderComment

varchar(80)

Default test order comment.

ExplodePackage

varchar(50)

Determines if a package code should be split into its constituents at time of order.

This rule executes at the time a test is ordered on the order screen.

Enter Y or N

Y = explode package

N or skip this entry = do not explode package

ExcludeFromUnverified

varchar(1)

Determines if a test code should be excluded from the report that lists unverified tests.

Enter Y or N

Y = exclude test code

N or skip this entry = do not exclude test code

UserLocationPriority

varchar(255)

Determines the default priority to assign to the test based on the user location at time of order.

Multidimensional pipe delimited userlocation=priority pairs, with leading and trailing pipes.

Enter valid user location code = valid priority code pairs separated by pipes.

Value 1 = user location code

Value 2 = priority code

IE: |USERLOC1=S|USERLOC2=T|

In this example the system will default the test priority to STAT if the user’s location is USERLOC1 or default the test priority to Timed if the user's location is USERLOC2.

InsCodeForTestInsRules

varchar(500)

Used in insurance specific rules to mark a test as payable or not by an insurance.

Defines a list of insurance codes for which this test should be checked for rules.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid insurance codes separated by pipes.

OR

Enter |ALL| to check for insurance specific rules for this test for any insurance.

LISAccGrpCode

varchar(50)

Determines how the system should group tests to a lab accession if the rule for single container per lab accession is NOT used.

Enter a valid grouping code.

This grouping code will allow the system to group multiple containers in a single lab accession.

Should be considered for sites where the LIS accepts a container ID (CID) separately from the lab accession.

PerfLabTestGroup

varchar(3000)

Defines the list of test group code that direct where the test is performed.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test group codes separated by pipes.

Used as part of the performing lab rules.

ConvertByMPI

varchar(50)

Used by the CDC Interface to identify if numeric result should be converted from kilograms to pounds or pounds to kilograms.

Enter either KGStoLB or LBStoKG

Reference instructions for this conversion in the CDC interface.

CreateDate

datetime

System timestamp when record is created.

Informational

EditDate

datetime

System timestamp when record is edited.

Informational

ExcludeFromNotInBatchRpt

bit

Bit flag that determines if test can qualify to appear on reports that show tests not yet batched.

Skip this entry so test will appear on NotInBatch reports.

Enter 0 or 1 or skip this entry

0 or skip this entry = test will appear on NotInBatch reports

1 = test is excluded from NotInBatch reports

Used to exclude tests that are not important for batching like comment tests and RESOE tests so user does not have to troubleshoot as many items.

TestPerfLabCodeList

varchar(2000)

Populates drop-down list of performing lab codes, for this test, on the order screen, based on permission.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid performing lab codes separated by pipes.

FinTestCodes

varchar(500)

Alternative test code(s) sent in Billing files instead of the lab code.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test codes separated by pipes.

ABNEnglishFreqMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of FREQUENCY.

Default message will be used if this field is blank.

This message should be for ENGLISH form.

ABNSpanishFreqMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of FREQUENCY.

Default message will be used if this field is blank.

This message should be for SPANISH form.

ABNEnglishExperimentalMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of EXPERIMENTAL.

Default message will be used if this field is blank.

This message should be for ENGLISH form.

ABNSpanishExperimentalMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of EXPERIMENTAL.

Default message will be used if this field is blank.

This message should be for SPANISH form.

ABNEnglishDiagnosisMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of DIAGNOSIS.

Default message will be used if this field is blank.

This message should be for ENGLISH form.

ABNSpanishDiagnosisMessage

varchar(255)

Alternative ABN message utilized when test fails Medical Necessity rules for reason of DIAGNOSIS.

Default message will be used if this field is blank.

This message should be for SPANISH form.

LabCode

varchar(50)

Lab code for this test code.

Enter a valid lab code.

SourceSystem

varchar(50)

The test definition system/vendor/version ID.

Enter a valid system/vendor/version ID.

Connects to the organization source system definitions.

RequireAddionalDemographics

bit

Future Use

RequireOrderGuardian

bit

Bit flag to determine if guardian information is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = guardian information is not required

1 = guardian information is required

RequireOrderGuardian16

bit

Bit flag to determine if guardian information is required on the order screen for patients younger than 16 years old.

Enter 0 or 1 or skip this entry

0 or skip this entry = guardian information is not required for patients younger than 16 years old

1 = guardian information is required for patients younger than 16 years old

RequireOrderAddress

bit

Bit flag to determine if patient address is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = patient address is not required

1 = patient address is required

RequireOrderEthnicity

bit

Bit flag to determine if patient's ethnicity is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = ethnicity is not required

1 = ethnicity is required

RequireOrderRace

bit

Bit flag to determine if patient's race is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = race is not required

1 = race is required

RequireOrderEmployer

bit

Bit flag to determine if patient's employer data is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = employer data is not required

1 = employer data is required

RequireOrderLMP

bit

Bit flag to determine if patient's LMP data is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = LMP data is not required

1 = LMP data is required

RequireOrderOccupation

bit

Bit flag to determine if patient's occupation data is required on the order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = occupation data is not required

1 = occupation data is required

RequireOrderEmployer16

bit

Bit flag to determine if patient's employer data is required on the order screen for patients who are 16 years old or older.

Enter 0 or 1 or skip this entry

0 or skip this entry = employer data is not required for patients 16 years old or older

1 = employer data is required for patients 16 years old or older

Be sure that you do not set both this field and RequestOrderEmployer16 to 1.

RequestOrderEmployer16

bit

Bit flag to determine if patient's employer data is requested on the order screen for patients who are 16 years old or older.

Enter 0 or 1 or skip this entry

0 or skip this entry = employer data is not requested for patients 16 years old or older

1 = employer data is requested for patients 16 years old or older

Be sure that you do not set both this field and RequireOrderEmployer16 to 1.

RequireOrderOccupation16

bit

Bit flag to determine if patient's occupation data is required on the order screen for patients who are 16 years old or older.

Enter 0 or 1 or skip this entry

0 or skip this entry = occupation data is not required for patients 16 years old or older

1 = occupation data is required for patients 16 years old or older

AskUserForWorkLoadCode

bit

Bit flag to determine when user is prompted to enter workload method.

 

Works with forcewrkldrequired permission which checks all tests ordered on the client-driven order screen when the Verify button is clicked to see if a workload entry is required (FO_Tests.AskUserForWorkLoadCode), and not allow the User to verify if any do not have it.

 

Rule is enforced on client-driven order screen.

Enter 0 or 1 or skip this entry

0 or skip this entry = user is prompted to enter workload method time verify order

1 = user is prompted to enter workload method at time order loads not at verify

 

This rule is applied at the time the user presses the verify button in the client driven order screen. If this field is set to 1, then trigger point is at time order loads not at verify.